import pandas as pd
import numpy as np
import plotly.express as px


all_data = pd.read_csv("spotify-2023.csv", encoding='latin-1')
all_data['streams'] = pd.to_numeric(all_data['streams'], errors='coerce')

most_streamed_song_by_year = all_data.loc[all_data.groupby('released_year')['streams'].idxmax()]

clean_data = most_streamed_song_by_year[['track_name', 'artist(s)_name', 'released_year', 'streams']]

fig = px.bar(clean_data, x='released_year',
             y='streams', hover_data=['artist(s)_name', 'track_name'],
             title='Most Streamed Songs by Year')

fig.show(renderer="notebook")

top_songs_by_year = all_data.groupby('released_year').apply(lambda group: group.nlargest(3, 'streams')).reset_index(drop=True)
top_songs_by_year = top_songs_by_year[['track_name', 'artist(s)_name', 'released_year', 'streams']]
top_songs_by_year = top_songs_by_year.query("""released_year >= 2010""")

custom_colors = ['#FF0000', '#33FF57', '#0000DD']


fig = px.bar(top_songs_by_year, x='released_year', color=top_songs_by_year.groupby('released_year').cumcount(),
             y='streams', hover_data=['artist(s)_name', 'track_name'], text='track_name',
             height=800, color_continuous_scale='Jet',
             title='Top 3 Streamed Songs by Year', barmode='group',)

# Customize the layout for better visualization
fig.update_traces(texttemplate='%{text}', textposition='inside')

fig.show(renderer="notebook")

song_keys = all_data[['key', 'streams']]
song_keys['count'] = song_keys.apply(lambda x:1, axis=1)
def format_to_billions(number):
    return number / 1e9
group = song_keys.groupby('key')['streams'].sum().reset_index()
group['value_in_billions']=group['streams'].apply(format_to_billions)
fig = px.pie(group, values='value_in_billions', names='key', title='Key share in songs')
fig.update_traces(hovertemplate='%{label}: %{value:.2s} Billion' , textinfo = 'percent')
fig.show(renderer="notebook")

C:\Users\Mentor\AppData\Local\Temp\ipykernel_11388\1587526722.py:2: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy

song_keys = all_data[['key', 'streams']]
song_keys['count'] = song_keys.apply(lambda x:1, axis=1)
def format_to_billions(number):
    return number / 1e9
group = song_keys.groupby('key')['streams'].sum().reset_index()
group['value_in_billions']=group['streams'].apply(format_to_billions)
fig = px.pie(group, values='value_in_billions', names='key', title='Key share in songs')
fig.update_traces(hovertemplate='%{label}: %{value:.2s} Billion' , textinfo = 'percent')
fig.show(renderer="notebook")

C:\Users\Mentor\AppData\Local\Temp\ipykernel_11388\1587526722.py:2: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy

data = all_data[['released_year', 'streams']]
data = data.query("released_year >= 2000")
data = data.groupby('released_year')['streams'].sum().reset_index()
fig = px.bar(data, title='Streams by year', x='released_year', y='streams', labels={'released_year': "Year", 'streams': "Total streams"})
fig.show(renderer="notebook")